Workday HR System API - Implementation Template
Mapping: Employee
| Workday | Response | Data Type | Description |
|---|---|---|---|
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/First_Name | legalName/firstName | TEXT(40) | The employee's first name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Last_Name | legalName/lastName | TEXT(80) | The employee's last name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Middle_Name | legalName/middleName | TEXT(40) | The employee's middle name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Last_Name | legalName/suffix | TEXT(40) | The employee's suffix |
| Worker/Worker_Data/Personal_Data/Name_Data/Preferred_Name_Data/ Name_Detail_Data/First_Name | preferredName/firstName | TEXT(40) | The name the employee prefers to be called |
| Worker/Worker_Data/Personal_Data/Birth_Date | birthDate | DATE | The employee's date of birth |
| Worker/Worker_Data/Gender_Reference/ID(@type=Gender_Code) | gender | PICKLIST | The employee's gender |
| Worker/Worker_Reference/ID(@type=Employee_ID) | employeeId | "TEXT(40) Unique-CaseInsensitiveExternal ID" | The employee's employment ID for the organization they were hired into |
| Worker/Worker_Reference/ID(@type=Employee_ID) | employmentType | PICKLIST | The type of worker (Employee, Contractor, Intern) |
| Worker/Worker_Data/Personal_Data/Contact_Data/Email_Address_Data/ Email_Address ( ID= WORK) | The employee's email address | ||
| Worker/Worker_Data/Personal_Data/Contact_Data/Phone_Data (@Workday_Traditional_Formatted_Phone) (Usage_Data/Type_Data/Type_Reference/ID = HOME) | homePhone | PHONE | The employee's home phone number |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Address_Line_Data (Communication_Usage_Type_ID=HOME) | addressLine | TEXT(255) | The street detail for the address. For example, this field is known as MailingStreet on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Municipality (Communication_Usage_Type_ID=HOME) | city | TEXT(40) | The city detail for the address. For example, this field is known as MailingCity on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Country_Reference/ID (@type=ISO_3166-1_Alpha-2_Code) | state | TEXT(80) | The state detail for the address. For example, this field is known as MailingState on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Postal_Code (Communication_Usage_Type_ID=HOME) | postalCode | TEXT(20) | The postal code for the address. For example, this field is known as MailingPostalCode on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Country_Region_Reference/ID (@type=ISO_3166-2_Code) | country | TEXT(80) | The country detail for the address. For example, this field is known as MailingCountry on Contact. |
| Worker/Worker_Data/Employment_Data/Worker_Status_Data/Active; Note: There is a transformation required here. If Active=0 and Terminated=0 then 'InActive'; If Active=0 and Terminated=1 then 'Terminated'; If Active=1 and Leave_Status_Data/On_Leave=1 then 'Leave', else 'Active' | status | PICKLIST | The employee's current work status |
| Worker/Worker_Data/Employment_Data/Position_Data/Start_Date | startDate | DATE | Start date of the employee's current status |
| Worker/Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/ End_Employment_Date | endDate | DATE | The planned end date for the employee's status |
| Worker/Worker_Data/Employment_Data/Position_Data/ Position_Time_Type_Reference/ID (@type=Position_Time_Type_ID) | employmentType | PICKLIST | The employee's full-time or part-time status |
| Worker/Worker_Data/Personal_Data/Contact_Data/ Email_Address_Data/Email_Address ( ID= HOME) | alternateEmail | The employee's alternate email address | |
| Worker/Worker_Data/Personal_Data/Contact_Data/ Phone_Data (@Workday_Traditional_Formatted_Phone) (Usage_Data/Type_Data/Type_Reference/ID = WORK) | workPhone | PHONE | The employee's formatted work phone number including country code and extension |
| /Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/ Manager_as_of_last_detected_manager_change_Reference/ ID(@type=Employee_ID) Note: Externalize the parameter Employee_ID as it may differ from customer to customer | managerId | LOOKUP(EMPLOYEE__C) | A reference to the Employee record of the employee's manager |
| /Worker_Data/Employment_Data/Worker_Job_Data/ Position_Data/Position_Title | positionTitle | PICKLIST | The employee's job profile at the company |
| /Worker/Worker_Data/Organization_Data/Worker_Organization_Data/ Organization_Data/organizationCode (where ../Organization_Type_Reference/ID (@type='Organization_Type_ID')='COST_CENTER' (depends on customer choice, based on a property) | InternalOrganizationUnit | LOOKUP(InternalOrganizationUnit) | A reference to the organization that this employee is assigned to |